package com.kayt.cyberBar.cuser.business.dao;

import java.sql.SQLException;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import com.kayt.cyberBar.common.PageData;
import com.kayt.cyberBar.cuser.business.entity.po.BSheetUserHistoryWork;

public interface ISheetUserHistoryWorkDao {
	Integer save(BSheetUserHistoryWork entity) throws SQLException;

	Integer update(BSheetUserHistoryWork entity) throws SQLException;

	Integer delete(Integer id);

	BSheetUserHistoryWork findById(Integer id);

	public PageData<BSheetUserHistoryWork> findByPage(int pageNum, int pageSize, String hql, Object[] params,
			LinkedHashMap<String, String> orderMap) throws SQLException;

	List<BSheetUserHistoryWork> getHistoryWork(String workCode, String startDate, String endDate) throws SQLException;

	BSheetUserHistoryWork findBSheetUserHistoryWork(String workCode, String shiftCode, String date) throws SQLException;

	List<Map<String, Object>> findBySotreCode(String sotreCode, String date) throws SQLException;
}
